Formulate Videos

The following tutorial videos cover the Formulate app and its different designers and tools.

Formula Designer Overview

An overview of the 'Formula' designer in Formulate and how to build calculations.

List Designer Overview

An overview of the 'List' designer in Formulate and how to build lists or sets.

KPI Designer Overview

An overview of the 'KPI' designer in Formulate and how to build Key Performance Indicators.

Parameters Overview

Learn how to incorporate parameters into reports, dashboards, and calculations.

Virtual Column Aggregation

Extend an original data model with new row-level column calculations that will be appended as new attributes or measures to an existing model.

Build a Formula

A guided walkthrough on creating your first formula for reuse in discoveries and illustrations.

KPIs

Use KPIs with dynamic banding to build intelligent, dynamic KPIs that are context-aware.

Using the Code Editors

See how to use the code editor to write both PQL and MDX.

Measure Parameters

Build measure parameters to inject measures into your query at runtime.

Custom Visuals

Build custom visualizations

Functional Selections

Learn how to build sophisticated custom business logic using functional selections .

Dynamic Captions for Custom Members

Learn how to add dynamic custom member or measure names to your calculations (advanced).

Current Member Logic

Learn how to use the Current Member function to build smart, effecient logic for classic analytic challenges.

Tooltips and Clickthrough

Learn about tooltips and how to click through to the graphical user interface from custom formulations.

Shared Tools

These videos cover tools that work in multiple apps in the application.

Buiding MS Tabular Models

Use Pyramid to design and build a Microsoft Tabular Model. Then use the model in Discover and Formulate.

Buiding Exasol Models

Use Pyramid to design and build an Exasol database and analytical model. Then use the model in Discover and Formulate.

Quick KPI Wizard

Use the Quick KPI Wizard in Discover to quickly build KPI measures for scroecards and gauges.